MySQL root密码重置 报错:mysqladmin: connect to server at 'localhost' failed的解决方案 | 您所在的位置:网站首页 › failed to connect mysql › MySQL root密码重置 报错:mysqladmin: connect to server at 'localhost' failed的解决方案 |
===========================================================二,忘记本地root的登录密码解决过程:1、编辑/mysql/my.ini在[mysqld] 配置部分添加一行skip-grant-tables 2、保存后重启mysql[[email protected] etc]# service mysqld restartShutting down MySQL. [ OK ]Starting MySQL. [ OK ] 3、登录数据库重新设置root密码[[email protected] ~]# mysql -u root -p mysqlEnter password:直接回车进入 Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.1.47-log Source distributionCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || test |+--------------------+3 rows in set (0.00 sec) 执行下列语句 mysql>use mysql;mysql> update user set password=password("mysql") where user='root';Query OK, 4 rows affected (0.00 sec)Rows matched: 4 Changed: 4 Warnings: 0 mysql> flush privileges;Query OK, 0 rows affected (0.00 sec) 4、删除/etc/my.cnf文件中添加的“skip-grant-tables”行,重启mysql;用新设的密码就能正常登录了; |
CopyRight 2018-2019 实验室设备网 版权所有 |